SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485715 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485715 [ RunTime:0.002756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28687,100043,435495,125083,997843,46086,254715,835169,961362,381170,267913,305881,535490,152791,650091,814415,761017,520169,1037852,189286,1041397,1036590,324105,481751,666279,423491,533781,88577,482163,63795,561655,219951,288522,665493,590613,852042,422855,1031912,438040,903366,389892,413287,836278,387910,544872,1040978,461036,128606,394512,901624,168865,499373,521588,357894,585079,1038587,36469,909399,891644,70374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]