SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198028 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198028 [ RunTime:0.002388s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045258,344120,740925,996716,885107,716930,596802,4367,464303,947933,810141,518180,1038149,791023,5228,503576,847532,350844,784638,732873,737390,886615,601166,536253,49010,581955,806703,1024654,415151,695472,728842,561870,781677,45104,29138,126322,1046389,963275,959571,371573,531982,538196,526866,496673,876426,506467,172253,736956,322137,1040329,846800,1044030,832470,890417,362044,177663,97277,608341,599526,876941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]