SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452056 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452056 [ RunTime:0.003872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257165,356487,604694,853521,473459,988420,472304,967164,726619,521412,769641,214485,519371,757649,474671,469639,306260,350263,200571,454651,750041,858687,466450,575569,919269,326786,278231,839712,341161,949718,484433,979714,551835,585458,216614,560503,446107,586348,398,687606,1027263,238695,495383,5555,722190,249513,683846,994407,25783,834238,989360,483836,986638,168335,639990,1010739,1009551,295138,393598,889194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]