SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31983 LIMIT 1 [ RunTime:0.001213s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31983 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892023,281960,857566,205591,370996,232306,248342,315223,289099,397350,512802,830803,413881,522379,147875,860748,386564,819951,859920,432713,589377,978132,416155,189894,358900,565221,268603,125446,364062,460424,104354,765837,541855,248074,175251,255279,592858,791831,876370,226337,883115,798990,423249,769665,214034,865868,645290,158774,441597,955282,549642,617949,774219,149186,150209,928733,960860,259525,833965,697530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]