SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 389903 LIMIT 1 [ RunTime:0.000873s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 389903 [ RunTime:0.002168s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741172,975631,369243,984885,263204,1042403,549989,832159,685529,340390,24356,223575,120275,271213,547780,427352,852561,480858,801486,572078,261540,356566,507688,277077,248935,263279,164573,738419,69950,30469,423494,1002927,745711,679943,491528,633448,985322,822969,344820,121480,716465,457474,834149,643422,615370,142479,786903,965805,896116,306541,1042014,43959,348064,1016108,703179,856641,357093,608639,515655,307674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 389903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 389903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000382s ]