SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486021 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486021 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598017,603840,361850,956821,916497,387371,956914,915094,861901,279667,23745,327907,871964,596128,845719,358016,137682,564310,55025,109804,356052,325975,527726,352264,761051,788757,508952,439877,831130,395047,115854,943117,362900,556713,187162,82499,91235,181251,275774,352628,654196,831291,23563,501590,417798,312403,980177,35042,71762,593058,1009670,1013460,707648,201426,75822,1000578,158413,175157,898806,264139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]