SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305456 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305456 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415488,587464,1031627,962230,963204,951399,792423,415003,433788,648835,569533,583817,180017,123065,327355,684113,463500,42181,918246,649359,747854,703885,973819,517010,697413,892059,629721,375221,498793,694648,48754,21414,732755,245717,627454,504094,593893,17986,596986,382206,990123,817133,1029685,461266,287330,868172,838791,430512,599146,168786,953152,997399,24516,28495,1014905,169698,422894,144098,919568,201868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305456 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305456 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]