SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801098 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801098 [ RunTime:0.002416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (770546,845296,699307,622518,844908,46043,616650,668188,437799,563076,854116,121426,197510,226928,240069,876659,89025,974052,46519,444683,266108,378448,420816,928653,519815,73725,868464,176521,323212,509531,208496,409930,170653,691459,318963,784670,196726,950474,428474,751442,515095,372585,701285,113194,541204,320759,443192,605201,996699,915661,225695,110126,942976,911494,635578,901834,18702,635764,1006090,945337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000781s ]