SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567923 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567923 [ RunTime:0.002080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29652,294240,661303,608452,262772,670098,26976,572783,909691,928250,417893,1035035,682573,152913,470556,211488,517093,533186,18078,306927,533307,647439,139764,126171,589450,695298,769529,696426,528437,473684,267916,866110,789852,839325,205554,938672,204157,311431,312799,185580,698146,223097,222354,326555,708137,37141,336788,195584,621895,575434,335771,364032,627330,77720,74114,493270,779645,685495,322867,704074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]