SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50833 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50833 [ RunTime:0.001968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112749,915792,931280,789926,987686,334043,869577,85687,257763,53464,745112,674323,513208,196156,693673,368644,353483,794876,270294,366747,852663,983806,283136,723505,40383,553019,504083,10513,426178,326846,536261,937599,140163,72951,1031676,882531,35015,21325,797754,761079,454993,609040,557576,180088,452362,295916,725793,661193,580216,60199,897620,686938,967422,738461,121403,391602,726897,197381,996855,749334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]