SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471211 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471211 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (386730,325216,454455,102328,600136,504744,795473,553088,706210,228304,443216,556389,778194,719934,678397,735833,35249,564160,707878,1032634,9091,1001864,418351,913098,61143,920550,638857,449715,956330,153940,666491,162605,844564,438986,444003,347175,334327,32335,531903,654384,607850,809807,982483,562660,155107,775736,1025549,133008,535361,143782,29137,646315,593052,952048,778646,552957,425246,162797,339877,781750) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]