SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201554 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201554 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (76099,864914,854825,916939,253521,340446,996512,465419,987565,1029863,278227,1046260,10606,944119,549110,395005,405842,860278,349757,144418,488473,876073,974956,200200,493938,902099,989861,117702,679318,234789,29093,231020,393674,114306,734634,787859,587892,781116,853306,284626,1033891,944772,909403,442002,647698,436917,334314,56929,572024,410613,432442,522133,780344,421359,936662,877803,774190,462130,674058,393101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201554 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201554 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]