SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508398 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508398 [ RunTime:0.002348s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371919,326165,826012,634201,195271,889563,769584,867391,670643,829538,713607,202764,554861,8042,134858,661946,157269,785520,904468,613984,1028973,401009,468677,774766,710663,873560,473318,578994,79166,1017340,807260,623691,131083,904271,287699,153362,594187,791665,69295,475372,982925,758518,385505,404980,968701,984389,436707,39327,258526,690112,283751,262644,1027120,411288,353661,778194,176469,189495,100542,30451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001757s ]