SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5041 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5041 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497909,783439,806078,667816,665989,298163,157443,917775,1041642,405336,527368,817544,487634,626961,707560,426077,129773,1046183,634403,569366,856543,732431,248452,668119,559090,618725,779553,227071,111261,723920,487658,1011845,649861,232424,630144,749655,428829,700681,33802,82060,247403,881580,645688,618868,501428,810322,674583,945601,525009,976703,607417,334250,66061,1010090,822831,255823,141462,830494,263977,736889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]