SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011260 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011260 [ RunTime:0.002644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249032,130952,972570,357780,1021859,816003,353138,314946,873024,235586,90825,993088,54064,458110,701304,517525,300123,850975,848127,902202,460998,1031410,376750,155440,1032131,550983,3317,754309,352644,796327,158186,324989,819681,64372,674206,640671,371381,919274,263605,639511,336721,218528,913591,641469,594526,876821,216651,813712,71797,534038,389469,995497,88670,588179,272494,407547,498425,361055,370833,225458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001740s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]