SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540842 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540842 [ RunTime:0.003512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (817909,617225,179529,1011692,583844,344398,378990,626450,163324,998505,649758,15677,65402,142410,755328,246968,221489,67659,397740,526081,373912,729407,1033962,836654,46736,815306,221758,415817,525780,879837,393764,838424,1024176,583222,661852,363820,199468,153253,45785,357636,354827,294011,655673,730185,62030,594511,801416,322329,481159,578370,1015137,848924,817732,706618,354195,1048229,123621,364701,442738,90310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002805s ]