SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351022 LIMIT 1 [ RunTime:0.000554s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351022 [ RunTime:0.002101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721003,603768,781352,114907,186382,979145,1018426,693935,12190,528091,69482,1044081,126125,862522,528476,563728,458654,70523,499591,137353,539843,939586,235797,575014,285677,55107,778437,630238,769404,73776,92771,602600,126003,69501,831449,687121,1015158,177798,4111,650225,193729,957152,1040022,732230,946087,980346,882799,428911,422531,584642,907479,407101,425054,69207,544760,444988,170796,8739,945603,870157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]