SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340515 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340515 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984302,111575,1031074,375384,444643,798401,485692,956471,762363,42288,115777,977626,691529,259690,462637,708376,1040373,583589,1045573,829080,194298,33659,1036261,23104,691398,502236,20713,176542,675328,909558,911841,86021,127302,326495,28060,421400,729982,970316,410003,607648,397926,424154,916856,635238,881898,1031199,189387,325767,260153,905466,165526,166514,627685,501028,125732,213461,646898,677519,116729,164690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]