SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381526 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381526 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600818,410895,67399,77189,203316,792048,8970,353928,605369,852924,355208,567758,314690,523806,67524,726027,255027,496770,489210,192933,666770,286844,575839,880188,592048,480651,813037,356432,313295,290755,171183,941469,23866,40616,904843,938266,958380,2693,724546,378912,692114,1023650,985826,66966,84004,820481,8202,291268,689665,462819,178336,520845,443957,483607,223197,333811,556885,929677,1020572,544537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]