SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501554 LIMIT 1 [ RunTime:0.003674s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501554 [ RunTime:0.002082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486059,204284,400448,54708,315785,790355,233770,131017,732638,579892,402636,915117,352211,408052,758843,434932,815716,950525,1533,333849,529276,466479,243739,444192,837421,319149,852004,533746,877420,1047769,116512,366716,880631,121765,625469,804082,11844,279287,382539,151537,826518,972206,715480,196557,247277,961948,154072,66897,229068,294938,301029,221750,1036366,176381,29624,385701,496413,164874,729581,790203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501554 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501554 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001418s ]