SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150651 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150651 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (963254,483146,236070,882933,395073,392106,185605,165359,579156,778187,744996,637813,179021,390904,854623,288218,8398,671752,245225,532595,810924,362533,557713,935728,816850,232729,661663,68311,975296,596800,299980,145668,965401,241424,525058,276956,292265,303937,441174,170520,558689,362384,777841,810322,121921,974199,745554,22457,209970,636330,192059,362900,133103,697041,986468,793475,86809,7542,1026061,93031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]