SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3599 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3599 [ RunTime:0.002585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924228,358335,331630,375656,6447,129544,209870,790845,517215,229166,955863,852595,244087,1033524,413411,864628,283506,476170,563359,13150,251271,536263,853417,511330,382177,348103,673961,751879,266087,158810,671392,203749,525666,3557,235773,208951,941800,971716,764474,409134,696456,871884,638927,581521,242,483408,238041,471598,119225,893402,612426,123325,1020791,247247,822104,469781,200828,946036,393266,975658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001473s ]