SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001696s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515143 LIMIT 1 [ RunTime:0.001843s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515143 [ RunTime:0.004510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539818,160336,1007849,780115,317119,262740,131572,806632,953060,521665,997309,724825,797877,375214,502115,420763,575925,715182,725099,902842,930315,828383,395943,657324,937005,609201,50001,469034,743402,856956,504773,237104,492984,474468,37698,361157,545498,672978,80611,353671,583400,400423,43808,290765,809786,451159,457063,88185,967459,436482,383656,787077,948662,626428,462483,244945,972735,272410,992634,640619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003910s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001564s ]