SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40358 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40358 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886911,140332,1024720,993248,221825,874357,543885,96617,740121,650931,1030398,927444,75919,1047804,75675,498336,399002,637156,136596,880845,622703,618638,646114,715619,833723,518215,1027102,657302,168846,615436,16832,942983,641912,193642,41165,271669,252955,77238,848003,200259,896377,610405,721268,80499,88969,595748,449044,247838,799735,32995,703643,68911,717024,850817,324730,826995,713301,162197,73875,881002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40358 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40358 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]