SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336508 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336508 [ RunTime:0.002297s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481562,323394,438026,494625,314375,62477,611578,546353,715488,394926,435319,811762,515684,808032,107488,558457,29219,574747,166831,457690,198663,1007238,547519,305947,795215,403389,333166,643894,662261,222818,953964,841909,40292,5530,283158,164589,403147,988871,308402,1048878,900455,366945,889830,1047087,511512,333386,233459,1043404,799171,263246,852435,530970,255474,712977,918421,230745,1048840,813564,645178,572455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]