SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021539 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021539 [ RunTime:0.001464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199728,805937,906061,846484,386047,822577,432051,195977,473369,225740,857654,559662,881090,590083,105657,77531,1010823,22748,345179,490864,417456,315238,615499,933401,323343,662857,768918,483014,298245,419653,421462,26662,181675,629390,415016,311162,828280,399102,80402,274817,33389,334665,676596,517445,57998,402902,275208,671171,955826,728596,660794,96619,843645,880616,220052,386013,268335,897914,939517,403700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]