SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002678s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021558 LIMIT 1 [ RunTime:0.001377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021558 [ RunTime:0.002124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606609,410805,928071,548704,988382,658189,374411,70984,919148,668189,495510,447701,507165,343240,244160,788931,235714,357969,825311,652897,345521,1024517,116687,428635,75714,88498,513372,325101,11475,710722,386097,582639,817482,629347,100394,709387,459608,230863,379703,154106,485333,731688,117852,166719,640292,762698,557797,810030,927059,259483,543504,147190,491597,329362,871501,140194,443087,366270,537458,746272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021558 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021558 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001818s ]