SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565315 LIMIT 1 [ RunTime:0.000274s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565315 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530311,605818,1029535,191072,685275,387414,737762,13579,844318,824396,150976,12063,36922,801775,490486,948024,99348,312472,550431,388513,240830,863822,330156,737746,16706,14220,422710,77922,319830,560213,1048639,218094,567534,295352,179730,15421,361862,542153,22296,122565,514317,527861,581485,1024310,590210,29044,118680,710581,908500,751947,845940,51397,1041009,541274,184200,280471,764491,425132,579394,380109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]