SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002800s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 252540 LIMIT 1 [ RunTime:0.000676s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 252540 [ RunTime:0.002217s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (913814,989658,337350,622603,590919,451866,119485,384739,814519,853917,733411,607867,775432,455952,142597,561666,871044,1030945,230657,801685,67433,443500,896753,201967,761527,655756,1016719,620513,12971,387650,272739,161661,673315,252240,580629,581023,866119,400155,994473,148616,72123,616656,95417,700446,281146,304711,71056,1022818,504509,104779,738101,612085,656937,178748,104945,85042,819576,285426,1009621,29307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 252540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000792s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 252540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]