SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001974s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391935 LIMIT 1 [ RunTime:0.001126s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391935 [ RunTime:0.005993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471211,290412,6600,962017,162874,192659,16897,167911,992378,395783,608019,311934,28369,502377,820312,363995,995154,469808,752385,867435,176271,1019854,154658,1022482,715090,420845,78594,956000,293093,136214,743128,666740,869426,516681,797252,487860,566288,291169,13493,529475,691678,551483,511638,957067,26996,368776,498152,271850,354911,663935,543406,100363,445334,517437,868021,476952,27760,225041,16506,44654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001094s ]