SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406516 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406516 [ RunTime:0.003556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532620,832727,84535,559797,339917,1022003,248797,964284,1013405,943176,871603,967100,666564,843129,418977,60662,214896,133484,181734,645480,271348,386188,983310,429020,627330,457943,335792,620798,230966,800908,785206,646674,354437,111209,659104,913911,345077,871803,71055,310008,185314,743058,192983,5184,595079,366003,6309,111982,314530,478564,803147,576947,209762,1040493,98725,472815,1029594,322780,294035,1011168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]