SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 158414 LIMIT 1 [ RunTime:0.000549s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 158414 [ RunTime:0.003968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109562,525913,136992,299200,800140,581872,667188,281541,722320,561518,179946,437845,1012121,102980,75054,235247,371372,1014753,466763,296720,135037,997577,512530,157392,854788,716782,898494,106264,852035,138088,770059,1046219,774363,864373,287308,766118,429156,1002932,389061,863363,521962,292738,779544,257129,389434,62591,226324,886648,671594,726199,872881,250851,418139,75258,355622,665537,317652,641146,284189,403454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 158414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 158414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]