SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391950 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391950 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274796,793169,248122,502156,864961,645446,22810,1011450,601290,69920,860012,268875,876589,750110,293329,516776,221353,354208,123459,374711,551153,928549,83235,478399,1021454,895153,488199,251341,989244,702700,944635,833707,549582,850069,694964,785851,656820,884453,952805,931655,190641,1028460,268064,745740,349412,168249,715380,177971,562474,285096,161967,262276,957504,591647,486568,744045,652081,495745,103686,742350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]