SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560580 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560580 [ RunTime:0.003509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (687259,734918,735586,451086,271340,1029087,243343,146262,999161,766854,578582,61013,1017314,221770,815565,364573,465882,710629,866153,515025,480583,616124,90996,342674,33454,752091,441290,838607,385705,723732,278322,973909,1000450,815057,821514,373466,718719,623780,816457,471430,588203,781241,388198,463127,965311,546942,721763,587325,637021,763255,391825,780412,411260,163514,1013159,873578,746918,344878,407383,543077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001105s ]