SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499492 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499492 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406213,236782,865190,317989,113276,388,708835,953310,132566,1014861,582232,249294,308602,868726,830696,903289,779113,780216,779175,768496,952008,566083,699347,816950,34225,559888,997259,574915,501471,708109,258852,631927,1017421,1003461,399452,667199,910616,157307,774648,848210,1041323,537645,911753,526196,427578,903198,637130,109863,488131,710475,341272,883471,872894,267274,387266,762152,288672,607602,569106,801533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499492 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499492 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]