SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019578 LIMIT 1 [ RunTime:0.002493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019578 [ RunTime:0.003360s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (679366,360435,680251,981120,560163,600133,645641,438571,206312,631228,746855,439436,66305,1010617,691247,904579,429649,888735,403753,180517,892003,180746,726545,202266,212338,552752,91418,368198,355343,807973,845725,825617,568454,544739,181102,248014,1027224,129289,67273,184659,432356,983034,647874,67045,954746,9363,714432,531723,155438,503194,776874,513619,735938,187883,936932,182907,103839,36288,878295,875134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]