SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406263 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406263 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581317,24982,998833,854164,363764,366811,1003564,519352,440370,862998,766340,790851,39962,44352,676545,740106,131482,669031,5249,437635,209725,472656,736186,851376,819533,1013587,134748,780747,895792,674007,921559,544665,219458,1047499,135365,818168,895875,427657,280371,370451,826625,517152,37351,1023967,366964,883153,1017913,558240,1027806,511116,653812,324474,12067,722699,361719,803522,1047823,973950,734875,445222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]