SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514968 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514968 [ RunTime:0.002695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423334,1039342,804272,249891,188988,777510,289241,771380,870967,108197,982914,1037242,54360,122869,870303,961747,144131,615711,333861,14115,365434,358387,930867,867283,910004,514208,452737,677599,658778,865738,745270,151765,16472,940111,500714,1006505,200751,172895,498936,685922,723634,966085,741212,118231,504841,752444,463040,525832,316394,550358,583184,1035742,806556,521574,901165,738918,765837,897590,430882,721062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000395s ]