SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001871s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508978 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508978 [ RunTime:0.003869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115901,97265,216125,589610,314510,56851,571610,556405,904479,940833,1014304,928717,274989,122253,250776,504751,113552,26732,380972,237021,332552,1047219,612351,941081,88323,937093,316860,591286,601362,628452,762732,755928,129165,302156,943598,774753,813245,277673,639524,662067,12145,295498,250142,435720,911152,159737,341089,775937,266395,879579,596212,481149,1029850,571210,343887,134880,210256,1030701,525609,365936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001622s ]