SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195269 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195269 [ RunTime:0.002125s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487046,772348,501958,59743,767119,781884,96256,291544,217370,392765,1032724,127560,1008616,290902,911026,460365,861421,962035,271057,179218,453953,1043931,181714,891861,119603,226071,1030421,753875,440488,819321,610545,763561,960404,218803,230877,1020015,502211,396825,211204,30570,424481,134642,844037,563952,998242,1041004,197597,118437,318658,754090,543623,172466,925988,1027578,812077,773907,772470,603968,759119,170282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195269 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195269 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000988s ]