SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501103 LIMIT 1 [ RunTime:0.000886s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501103 [ RunTime:0.003236s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (983144,453814,780891,352990,927009,547170,62254,549255,1005937,332696,387329,1043501,765944,1039790,333348,470617,290955,422641,231399,220758,574235,143233,308012,384273,229837,772830,511987,167981,551071,545424,926344,931105,401110,221636,693951,419182,402583,818377,846197,638768,613204,512994,634352,703806,817363,745458,477428,967296,97169,761762,693667,763905,37783,857788,437104,57863,453620,96953,593763,1031610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001808s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000700s ]