SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40241 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40241 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536707,506517,520053,102864,602818,287387,581011,917556,636908,542477,969728,448557,358622,332767,75934,403093,893289,920985,126348,206445,412032,229154,448021,566219,794876,53639,501279,114907,1034884,120002,1039361,745922,389528,1014993,294700,278528,210687,965647,371840,431732,465270,1004176,297106,882685,32982,930986,515027,773433,133765,29153,406989,600007,754405,617488,950422,110348,381319,1013358,402232,457853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]