SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421751 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421751 [ RunTime:0.009953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586518,744908,2976,1005765,970360,785349,956829,864654,527528,825420,786888,155470,643864,239541,501958,1048121,662561,395549,307068,493160,170836,98398,367987,123577,119457,21592,33545,584007,683455,628891,483850,321232,263453,411881,421734,822568,894049,290333,489800,466837,1045363,864186,479756,532874,571317,317514,153528,718247,535037,694734,182230,450017,578507,365524,623859,933657,829961,713005,1019190,685721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]