SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001587s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502548 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502548 [ RunTime:0.004444s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123692,402682,726811,747605,192429,704848,675099,680106,140412,589600,898330,986384,612544,512336,799829,423427,241077,299247,128748,18085,611522,994369,400587,239621,622725,355488,708497,579420,551166,836080,299107,51538,201414,620213,651017,760972,422259,813000,792392,803556,965438,281792,93363,705483,439225,348854,763015,169002,347506,925037,104884,967458,350282,84291,403029,679263,859117,980230,415287,377109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502548 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000688s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502548 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001042s ]