SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569078 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569078 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206279,468522,779304,809762,149994,277921,356250,1036962,491532,341307,294565,113781,63005,359790,241228,327126,46941,435736,859458,15361,1008797,724319,775548,39460,34807,589567,967200,634740,421086,230270,100597,374975,88308,489662,899118,370148,968989,385682,241694,711043,674962,835585,897475,866941,152587,8923,146307,476580,1004068,772986,27912,127547,694996,683009,369127,674635,268746,129293,29268,933836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]