SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301960 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301960 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381634,999807,89928,795142,721986,1015900,170797,714638,1019805,876140,615045,223582,427575,758535,870338,11007,128977,859205,772032,996180,1031532,35537,780996,87062,847401,710022,238906,839022,435762,311435,952914,873533,339201,12732,836168,1010597,727445,558884,36871,430538,441417,773775,168880,1000919,372877,802611,290562,309701,466875,492462,867213,750375,620963,772533,462103,407376,170487,243516,1010297,517500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301960 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301960 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]