SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323283 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323283 [ RunTime:0.002103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005795,63344,941515,661166,806458,989632,743818,318950,268037,223590,855681,682948,981379,588085,473194,434506,456325,178780,738313,830215,316451,410321,626126,1000053,877256,108537,595629,395115,439422,792502,575820,287209,711960,365209,290632,49709,629437,410277,397415,289884,789867,750624,580469,868250,920347,76678,503632,934812,548835,328487,358877,178775,426860,227049,937569,735742,99292,178565,706450,969938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]