SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532101 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532101 [ RunTime:0.001369s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840622,884576,250342,912546,513235,146342,70155,226577,260889,588355,103934,921985,397504,411504,124075,928429,656578,797900,868013,309885,580901,422097,281756,710448,148415,703829,677138,389762,927926,666598,262824,635235,757727,342686,134590,1023515,640995,109833,116458,616922,376134,366597,475301,771682,1047034,7954,339547,151610,67553,152123,888967,506183,291436,168406,778745,987760,765372,1043734,327325,57780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]