SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499211 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499211 [ RunTime:0.002216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5777,995300,46234,48513,25378,502193,520710,462202,988679,292223,616853,168735,638767,344933,115256,792819,335388,845189,387771,390300,939396,5369,798001,101222,790157,216044,369426,996423,197012,520560,644156,889559,242149,784000,982845,285106,549864,528880,692607,353703,642073,788990,416572,14842,798751,664926,885902,60072,42246,155098,103,128651,578575,222311,17695,273408,419632,555709,971627,953294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]