SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407125 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407125 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799438,1027217,1009090,644901,700682,956107,452718,1029221,172826,629748,189100,42980,107405,813474,336632,509899,252545,844735,411596,794699,703938,685330,891014,43581,428436,4310,828079,541058,112331,276582,731063,589813,85343,1023485,1014160,322803,482681,949729,410129,143071,169429,407368,269659,720580,117795,764487,887725,349422,237877,934388,137802,948198,335595,709781,411919,803796,32282,1015775,758107,56884) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407125 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407125 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]