SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564482 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564482 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59608,958853,620567,133485,677673,387480,204201,360100,743151,736793,35423,374380,230344,878497,610462,605439,817356,126857,831141,765711,911791,189988,36439,156588,185916,229549,915437,299638,706047,948339,545720,662669,342186,846346,64346,476561,330637,820626,845594,555594,691749,116403,723240,1037607,326858,291385,145633,182080,867422,799663,480291,820951,4250,690064,578631,191014,753916,147798,686938,349374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]