SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261883 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261883 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246962,211508,1022383,936723,573560,894999,401038,163621,659172,285376,642269,926061,257875,623559,308525,305839,168611,925489,889843,813871,1021611,342790,635550,739246,695226,150381,889282,792224,82808,396266,573890,148339,102215,844440,314112,271084,696966,837482,589455,597315,961111,140389,831624,670518,620319,284664,895586,442732,885760,516672,574551,1044957,407001,923814,590277,451063,193447,894548,153126,372364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]