SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539184 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539184 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485557,160098,558009,573234,993908,421723,7410,445701,841756,784674,110143,1036916,282605,750282,768821,847401,835756,108030,863086,947340,542523,590359,553806,968608,788297,55559,534303,583178,515573,65079,3718,86231,726069,537040,860823,739175,770617,807479,394576,567067,286010,1029434,205057,886949,258921,3595,81637,584636,69214,240880,848656,884309,910133,76363,389828,425373,734551,226806,1047341,234320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]