SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550128 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550128 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219825,1025431,898642,452665,359387,852333,197153,411007,599061,102032,638838,399691,818291,713410,507543,558327,108351,703585,347776,502307,670424,859189,385224,22798,341304,868794,121924,342881,247209,362194,839740,470223,207525,540374,939115,246136,651052,879653,501475,396640,559953,951529,963750,817540,548026,1024418,356529,518187,239194,50766,473275,633444,394319,1015819,6974,499386,835762,321733,403811,920586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]