SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490729 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490729 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840233,941776,96497,86971,1024188,156032,974740,579109,840046,720641,262616,469890,904934,413833,596835,497301,133563,112977,24199,281858,10211,507376,1017235,484236,404795,708470,1019924,223408,112871,696866,1033504,535861,32113,398808,341785,754478,210970,1010843,79906,89045,385537,669335,988715,855660,838874,1002331,619790,253619,24006,5689,819115,446666,139521,8481,435428,614809,680617,410181,716455,907827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490729 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490729 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]