SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 881811 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 881811 [ RunTime:0.001985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308682,235994,21341,78331,724517,504329,938491,788828,252173,175977,877292,259164,887844,652813,714113,214475,290159,843350,112671,847796,444456,486378,753840,334223,320086,432432,113446,603291,1025587,153008,359770,879808,23597,509284,941284,115616,313937,143065,233437,348076,1014636,370736,950223,452580,990913,228731,161408,795058,446097,199176,712165,692079,119166,471857,280216,337264,589987,241219,861473,1021980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 881811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 881811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]