SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320140 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320140 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26682,682994,513100,291874,907642,276535,188593,321560,244592,680532,512509,77446,34341,794448,388892,478067,400791,377594,174861,669172,339976,365797,848848,556172,781536,947828,1034158,424871,4398,773303,491185,1022973,430480,90099,237977,819297,225746,158349,825017,310544,413744,303007,211449,651744,318892,380201,72867,303414,492787,440882,894358,927047,253467,525987,826752,999292,456856,793484,381979,472588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]