SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535111 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535111 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341426,1001419,986641,828295,820889,507302,964006,801326,356277,1015024,391032,632183,28366,402737,317043,49088,929904,54782,546105,866685,185574,30291,375259,962358,794288,76205,1031083,22951,302199,809197,832616,450062,315325,774539,108625,403283,566221,1048205,683282,503068,915123,618275,930933,522578,832893,829033,1037264,1020444,833544,916437,454749,218875,43895,310376,678876,135785,16684,94722,583502,643682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]