SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342212 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342212 [ RunTime:0.003096s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733265,875933,578958,932095,117137,20927,663232,535586,646705,375458,743413,744420,483438,925,527066,197279,198067,652392,929179,215442,501511,544450,540672,941305,527808,738371,320335,28133,720714,637174,700474,620022,292321,40827,49434,437835,737444,334540,1047573,997467,73191,1044089,586241,671938,643602,866675,889020,854537,718397,771769,594430,169225,334215,939750,931353,138137,186620,919597,251166,474794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000738s ]