SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 55300 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 55300 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219284,990381,497453,356256,557218,719158,538321,673919,907368,950966,23417,447468,794265,72247,574895,196548,892378,650766,109294,428002,371970,815344,312510,1041558,216941,177587,536194,138363,852987,588632,730006,957241,615855,979650,470631,789260,951389,835420,947599,194942,99310,645415,706287,389405,58087,550149,888089,504540,1018557,207414,622679,452784,7545,385171,904618,243200,634494,41980,402263,818481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 55300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 55300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]