SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020135 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020135 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173221,247214,589050,103430,644129,757968,958319,39742,35703,251505,472418,1001208,686118,412060,604301,406387,779512,676222,758703,439846,104972,529952,328342,288638,944064,852870,608568,431173,243268,346362,405142,1039488,810490,757268,464303,717684,827739,918384,828432,561871,989964,232726,169940,145727,673666,266092,11392,1042086,275989,423703,222662,785014,498502,357994,666950,1046223,1000518,151454,478454,139173) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020135 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020135 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]