SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54278 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54278 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689629,68865,612867,895659,871524,854046,422285,990916,739758,1048419,394541,75145,36104,533816,972326,777490,296842,340901,537720,555662,529254,554786,472266,770226,832649,593108,622394,51492,128069,191720,169508,728514,51722,40384,391980,602275,965570,768474,573144,455103,800003,467328,805548,383899,323163,790979,663857,864421,896517,13425,944120,734035,698865,419553,537188,718515,474826,916008,287759,827866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54278 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54278 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]