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` = 574211 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574211 [ RunTime:0.001432s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961525,140817,165433,468138,875582,677491,121202,243110,371878,90834,603243,22889,615003,113795,663039,551380,1009565,1016468,587562,320595,422706,307552,969848,646174,506543,606119,709513,396820,698102,239559,45211,700204,558766,85581,410536,340151,231548,270736,234557,334952,790781,422100,652017,274469,334245,842829,45940,574634,720297,846148,168480,572966,657935,593572,701134,947988,596566,1016600,397514,440464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000830s ]