SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413506 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413506 [ RunTime:0.002174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699211,656958,273798,132900,716251,733021,608614,445077,643074,280307,847517,855839,699891,594721,1018882,781621,711205,940638,779142,485198,595192,391371,799180,252508,812668,267545,728670,968534,154384,505851,780284,457027,338122,104623,464392,743388,517066,816304,468268,809011,73214,715548,969842,443592,111248,959080,440660,838875,492865,941873,993450,1016128,874302,72140,266101,1005506,236624,501486,330959,850819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]