SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111057 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111057 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152696,146789,454617,955952,469353,580166,286160,601967,1004042,404192,848288,1035679,734685,366962,530466,980620,379784,908231,247114,147303,714071,956005,574205,959883,30785,731085,133225,476922,476629,1797,659397,785388,333785,767576,772481,997210,655019,12353,865341,771143,931867,729219,565372,539779,323569,336583,208333,103300,604737,452432,5305,671903,631872,1024228,566466,883819,12513,836154,402830,654148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]