SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002598s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598681 LIMIT 1 [ RunTime:0.002511s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598681 [ RunTime:0.004454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682778,155760,894152,772835,280908,307801,312612,378578,953123,106365,677439,541749,199821,166066,806292,554763,66616,217158,769830,143136,788769,179188,352952,203735,780809,540750,587745,694828,315560,603666,1004988,645817,90906,529224,453023,527430,224871,245899,611580,540999,826392,866095,516350,164714,154569,982788,770708,249982,760953,597749,813405,843454,596783,387564,820612,396644,513628,90628,911268,803174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]