SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002993 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002993 [ RunTime:0.002073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529916,575888,214557,611065,365669,217505,325302,869159,115040,747181,183679,207881,319163,618040,640718,608507,449019,176857,511163,827580,877800,168077,738871,407791,842801,330564,636660,620445,313563,445151,349121,316362,914154,927806,897675,462682,821577,334610,558532,734773,570822,692060,956258,689996,104704,547505,444098,699037,676150,46714,255771,119429,826461,96242,268848,524533,876661,594624,159399,645998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]