SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 277183 LIMIT 1 [ RunTime:0.000663s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 277183 [ RunTime:0.002708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642908,485477,752545,542290,456144,47830,702159,769722,79110,219689,735812,892714,962814,489204,340445,709518,528576,964472,597682,1000786,40127,274655,580776,555837,264412,547148,612929,117441,19357,768653,610982,738464,879152,335618,20961,900272,909047,654918,610109,811472,466745,35201,925283,823717,450364,884191,342227,1001809,638012,860871,1028385,184423,116490,543707,129997,226817,761016,1011452,936281,196240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 277183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 277183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]