SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544421 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544421 [ RunTime:0.002128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141267,231252,995057,352635,731052,1006041,666387,1024947,395711,729962,588,74532,108636,311001,202675,615893,716590,102070,65672,495202,441771,243210,448055,898661,829967,97573,122495,591316,719523,304247,237968,176169,794959,438155,790163,320577,723231,130152,429596,871268,662924,362098,445634,744343,892177,761814,89243,45835,306063,456918,907565,72998,487834,481519,50277,68256,787374,396781,553853,2461) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001136s ]