SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507016 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507016 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553617,271807,316245,269804,428364,69030,39927,1048144,712604,630543,827096,386516,168547,984594,615192,577525,109825,916170,1028411,126129,762530,272343,661157,351938,236544,136534,772035,882888,236868,338951,715621,184375,232410,692755,620896,433555,462268,993307,671895,164173,262051,866986,201,341597,861424,1039628,703768,888289,182275,288477,586085,529397,19672,194315,902671,372324,127224,1028261,300759,1004457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]