SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 273541 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 273541 [ RunTime:0.002880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274062,152550,320937,972556,520143,440360,354611,1149,935626,322875,569048,736427,376799,240895,113596,795281,47984,781547,398186,408077,321053,785454,941870,309638,32562,852399,503618,583987,79774,901347,1010746,769781,885634,69553,1029356,675631,74485,940229,526269,721666,795880,651331,633413,789913,162038,609944,76291,1030121,1005008,359091,613577,587873,943967,842569,367137,544898,299161,515471,794007,925739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 273541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 273541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]